Additional Unacceptable Values

Additional Unacceptable Values allows users to add additional pre-set values to your list of unacceptable values for the Unacceptable Values quality control (QC Quality Control) check. Using these options, leading, trailing, null, and whitespace values can easily be added to your unacceptable values list like any other value on this list.

By default, the list of pre-set options available are disabled. When disabled, the following values do not trigger a fallout: Leading Spaces, Null Values, Trailing Spaces, Whitespace with spaces only, and Whitespace with multiple spaces between words.

  1. In the Navigation Bar, select Account Settings.
  2. From Account Settings, select Data Target Configuration.
  3. Locate the Data Target Configuration you want to edit.

  4. In the Actions column, select Here is an image of an ellipsis, or dot dot dot, that when selected opens the Actions box with a list of available options. to view available actions and select Edit.

    The Target Configuration - Layers window opens.

  1. Locate the layer you want to edit and select Edit Layer.

    The Target Configuration - Layers window opens for the layer selected.

  2. Scroll to the Quality Control (QC) Checks section.

  3. Expand Quality Control (QC) Checks to view a list of QC Checks for the layer.

  4. In the Quality Control Check column, locate the QC check you want to edit and click the row to expand and view settings.

  5. In the Additional Unacceptable Values section, click the check box(es) to enable or disable the selected additional unacceptable values. When a check box is checked, the additional unacceptable values selected are enabled.

    When the check box(es) are unchecked, the additional unacceptable value(s) listed are disabled.

    Additional values include the following:

    • Leading spaces (One or more space): Select this option to add leading spaces to the unacceptable values list when one or more space is located before the first text character.

    • Null Values: Select this option to search and flag null values.

    • Trailing spaces (One or more space): Select this option to add trailing spaces to the unacceptable values list when one or more space is located after the last text character.

    • Whitespace (Contains just spaces): Select this option to add whitespace to the unacceptable values list when the entire value is one or more space.

    • Whitespace (Contains multiple spaces between words): Select this option to add whitespace to the unacceptable values list when there are multiple spaces between words.

  6. To save, click Done in the lower right corner.